Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Management Information Systems-Assessment 3

Management Information Systems-Assessment 3

Q Compare and contrast the differences between data integrity and data consistency. Please provide an example for each one. 75 words in length. Compare how the data in transactional databases differs from that in data warehouses. 75 words in length. How does Web mining differ from data mining? 75 words in length.

View Related Questions

Solution Preview

Data integrity and data consistency are both the characteristics of the DBMS that enhances its performance. The data integrity refers to the overall completeness and accuracy of the data in a database. Whereas the data consistency refers to the characteristics that ensures that the data is not violating the rules of the database. In other words, the data integrity emphasizes on the quality of the data, whereas the data consistency refers to the usability of the database. Due to the data integrity of a database, no string value would be included in a column showing the date function.